<?php
// Create connection to Oracle
        $conn = oci_connect("apps", "apps", "//dboftest:7040/FTEST");
        if (!$conn) {
           $m = oci_error();
           echo $m['message'], "\n";
           exit;
        }
        //$s = oci_parse($conn,"DELETE AERO_AP_INV_TEMP_INTERFACE");
		//$s = oci_parse($conn,"INSERT INTO AERO_AP_INV_TEMP_INTERFACE VALUES('ABE','F-5','','01-11-11','FUEL TAX','1','Bs','1','','','','1','21900514','212','000','151','BRM-MIQ','YV-287T','000','000','138','IVA-EXCENTO','1','Lbs','1','','1','COMBUSTIBLE','','','','')");
        //$s = oci_parse($conn,"SELECT * from AP.AERO_AP_INV_TEMP_INTERFACE");

        // Use OCI_DEFAULT to insert without committing
        //$r = oci_execute($s, OCI_DEFAULT);
		
		//$r = oci_commit($conn);
		//if (!$r) {
			//$e = oci_error($conn);
			//echo $e['message'], "\n";
			//exit;
		//}
		
		$s = oci_parse($conn,"SELECT * from AERO_AP_INV_TEMP_INTERFACE");
        $r = oci_execute($s, OCI_DEFAULT);

       while ( $row = oci_fetch_array($s, OCI_RETURN_NULLS) ) {
		   print_r('<table><tr><td>RIF ');
		   print_r($row['VENDOR_NUM']);
		   print_r('</td><td>FACTURA ');
		   print_r($row['INVOICE_NUM']);
		   echo '</td></tr><br>';
		}
		echo '</table><br>';
        // Close the Oracle connection
        oci_close($conn);
		echo 'cerrado';
?>